SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 61974: Filters might be reset after refreshing SAS® Visual Analytics reports in the SAS® Add-In for Microsoft Office

DetailsAboutRate It

When refreshing a SAS Visual Analytics report in the SAS Add-In for Microsoft Office, filter values might no longer be applied. Specifically, this problem can occur for filtered reports with multiple sections.

For example, suppose your report has two sections. Section2 has a bar chart and a drop-down list with the saved value Acura for the category Make. The following display shows this report:

 

You open Section2 in the SAS add-in, and then you refresh the report. After refreshing, the value in the drop-down list is no longer applied to the bar chart. As a result, the bar chart shows all values for the category Make, as shown in the following display:

As a workaround, reselect the value in the drop-down list after refreshing.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Add-in for Microsoft OfficeMicrosoft Windows 8.1 Pro 32-bit7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8.1 Enterprise x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8.1 Enterprise 32-bit7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8 Pro x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8 Pro 32-bit7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8 Enterprise x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8 Enterprise 32-bit7.158.09.4 TS1M59.4 TS1M5
Microsoft® Windows® for x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 8.1 Pro x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows 107.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 20087.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2008 R27.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2008 for x647.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2012 Datacenter7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2012 R2 Datacenter7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2012 R2 Std7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 2012 Std7.158.09.4 TS1M59.4 TS1M5
Microsoft Windows Server 20167.158.09.4 TS1M59.4 TS1M5
Windows 7 Enterprise 32 bit7.158.09.4 TS1M59.4 TS1M5
Windows 7 Enterprise x647.158.09.4 TS1M59.4 TS1M5
Windows 7 Home Premium 32 bit7.158.09.4 TS1M59.4 TS1M5
Windows 7 Home Premium x647.158.09.4 TS1M59.4 TS1M5
Windows 7 Professional 32 bit7.158.09.4 TS1M59.4 TS1M5
Windows 7 Professional x647.158.09.4 TS1M59.4 TS1M5
Windows 7 Ultimate 32 bit7.158.09.4 TS1M59.4 TS1M5
Windows 7 Ultimate x647.158.09.4 TS1M59.4 TS1M5
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.